create external  table  jms_ods.tab_dws_device_standard
(id                     string  comment 'id'
,center_name            string  comment '转运中心name'
,center_code            string  comment '转运中心code'
,proxy_code             string  comment '代理区code'
,proxy_name             string  comment '代理区'
,standard_efficiency    string  comment '标准效率'
,is_delete              string  comment '是否删除 0正常，1删除'
,operation_code         string  comment '操作人'
   )comment '中心标准效率配置表'                      --NVARCHAR2(64)
PARTITIONED BY (dt STRING COMMENT '时间分区')
STORED AS PARQUET
LOCATION '/dw/hive/jms_ods.db/external/tab_dws_device_standard'
TBLPROPERTIES (
    'discover.partitions' = 'false',
    'parquet.column.index.access' = 'true'
    );